Overview

Dataset info

Number of variables28
Number of observations340
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory87.0 KiB
Average record size in memory262.1 B

Variables types

Numeric17
Categorical5
Boolean0
Date0
URL0
Text (Unique)3
Rejected3
Unsupported0

Warnings

Sodium has 14 (4.1%) zeros Zeros
Carbohydrates has 19 (5.6%) zeros Zeros
Protein has 50 (14.7%) zeros Zeros
Energy has 18 (5.3%) zeros Zeros
Trans_Fat has 229 (67.4%) zeros Zeros
Cholestrol has 70 (20.6%) zeros Zeros
Total_Fat is highly correlated with Energy (ρ = 0.9065) Rejected
City has a high cardinality: 139 distinct values Warning
Saturated_Fat has 83 (24.4%) zeros Zeros
Dietary_Fibre has 117 (34.4%) zeros Zeros
Revenue is highly correlated with Number_of_Employees (ρ = 0.90912) Rejected
Sugars has 36 (10.6%) zeros Zeros
Number_of_Employees is highly correlated with Cost_Price (ρ = 0.90912) Rejected

Variables

Latitude
Numeric

Distinct count245
Unique (%)72.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean33.488
Minimum12.91
Maximum61.6
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum12.91
5-th percentile17.43
Q128.523
Median35.105
Q340.1
95-th percentile44.04
Maximum61.6
Range48.69
Interquartile range11.578

Descriptive statistics

Standard deviation9.9452
Coef of variation0.29698
Kurtosis0.32666
Mean33.488
MAD7.8009
Skewness-0.11623
Sum11386
Variance98.906
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[12.91 13.075 18.51 18.555 19.005 ... 38.905 42. 45.175 60.305 61.6 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
29.95 4 1.2%
 
38.9 4 1.2%
 
12.99 4 1.2%
 
39.13 4 1.2%
 
37.78 4 1.2%
 
61.58 4 1.2%
 
19.1 4 1.2%
 
40.11 3 0.9%
 
34.11 3 0.9%
 
19.07 3 0.9%
 
Other values (235) 303 89.1%
 

Minimum 5 values

ValueCountFrequency (%) 
12.91 1 0.3%
 
12.94 1 0.3%
 
12.97 2 0.6%
 
12.99 4 1.2%
 
13 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
61.6 2 0.6%
 
61.58 4 1.2%
 
60.49 1 0.3%
 
60.48 1 0.3%
 
60.13 1 0.3%
 

State
Categorical

Distinct count32
Unique (%)9.4%
Missing (%)0.0%
Missing (n)0
MH
 
38
CA
 
20
DL
 
17
Other values (29)
265
ValueCountFrequency (%) 
MH 38 11.2%
 
CA 20 5.9%
 
DL 17 5.0%
 
TN 15 4.4%
 
AR 15 4.4%
 
CO 10 2.9%
 
IA 10 2.9%
 
IN 10 2.9%
 
LA 10 2.9%
 
TX 10 2.9%
 
Other values (22) 185 54.4%
 
Max length2
Mean length2
Min length2
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

Sodium
Numeric

Distinct count134
Unique (%)39.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean490.46
Minimum0
Maximum3600
Zeros (%)4.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile5
Q1118.75
Median230
Q3790
95-th percentile1480
Maximum3600
Range3600
Interquartile range671.25

Descriptive statistics

Standard deviation538.23
Coef of variation1.0974
Kurtosis3.3506
Mean490.46
MAD433.98
Skewness1.6021
Sum1.6676e+05
Variance2.8969e+05
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 2.500e+00 2.650e+02 1.575e+03 2.275e+03 3.600e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
230 16 4.7%
 
0 14 4.1%
 
180 11 3.2%
 
140 8 2.4%
 
150 8 2.4%
 
170 8 2.4%
 
190 8 2.4%
 
135 7 2.1%
 
10 7 2.1%
 
240 6 1.8%
 
Other values (124) 247 72.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 14 4.1%
 
5 5 1.5%
 
10 7 2.1%
 
15 3 0.9%
 
20 4 1.2%
 

Maximum 5 values

ValueCountFrequency (%) 
3600 1 0.3%
 
2290 1 0.3%
 
2260 1 0.3%
 
2170 1 0.3%
 
2150 1 0.3%
 

Profits
Numeric

Distinct count334
Unique (%)98.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean4.6436
Minimum0.05
Maximum13.514
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.05
5-th percentile0.2664
Q11.8295
Median3.893
Q36.92
95-th percentile11.45
Maximum13.514
Range13.464
Interquartile range5.0905

Descriptive statistics

Standard deviation3.407
Coef of variation0.73369
Kurtosis-0.50969
Mean4.6436
MAD2.8554
Skewness0.67167
Sum1578.8
Variance11.608
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.05 2.9915 10.0525 13.514 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3.893 2 0.6%
 
1.778 2 0.6%
 
2.298 2 0.6%
 
1.548 2 0.6%
 
2.464 2 0.6%
 
6.656 2 0.6%
 
9.019 1 0.3%
 
8.065 1 0.3%
 
13.431 1 0.3%
 
6.695 1 0.3%
 
Other values (324) 324 95.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.05 1 0.3%
 
0.055 1 0.3%
 
0.058 1 0.3%
 
0.076 1 0.3%
 
0.127 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
13.514 1 0.3%
 
13.431 1 0.3%
 
12.745 1 0.3%
 
12.734 1 0.3%
 
12.536 1 0.3%
 

Store_Name
Categorical, Unique

First 5 values
104th & Tower, Commerce City
10620 Parallel Prkwy-KCK Speedway
10th St. & West Ave.
120 4th Street
12300 South & 1300 East-Draper
Last 5 values
Washington & Clinton
Webster & Atlantic - Alameda
Weir & Parkway
Whitefield
William Cannon & Westgate

First 5 values

ValueCountFrequency (%) 
104th & Tower, Commerce City 1 0.3%
 
10620 Parallel Prkwy-KCK Speedway 1 0.3%
 
10th St. & West Ave. 1 0.3%
 
120 4th Street 1 0.3%
 
12300 South & 1300 East-Draper 1 0.3%
 

Last 5 values

ValueCountFrequency (%) 
William Cannon & Westgate 1 0.3%
 
Whitefield 1 0.3%
 
Weir & Parkway 1 0.3%
 
Webster & Atlantic - Alameda 1 0.3%
 
Washington & Clinton 1 0.3%
 

Cost_Price
Numeric

Distinct count337
Unique (%)99.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean11.08
Minimum0.429
Maximum21.292
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.429
5-th percentile1.1656
Q16.5575
Median11.596
Q316.256
95-th percentile19.947
Maximum21.292
Range20.863
Interquartile range9.6985

Descriptive statistics

Standard deviation6.2044
Coef of variation0.55996
Kurtosis-1.2054
Mean11.08
MAD5.365
Skewness-0.16575
Sum3767.2
Variance38.495
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.429 4.236 6.4695 21.292 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
12.452 2 0.6%
 
8.106 2 0.6%
 
8.511 2 0.6%
 
3.304 1 0.3%
 
14.565 1 0.3%
 
16.76 1 0.3%
 
2.975 1 0.3%
 
18.467 1 0.3%
 
1.506 1 0.3%
 
14.181 1 0.3%
 
Other values (327) 327 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0.429 1 0.3%
 
0.454 1 0.3%
 
0.47 1 0.3%
 
0.559 1 0.3%
 
0.761 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
21.292 1 0.3%
 
21.178 1 0.3%
 
21.019 1 0.3%
 
20.96 1 0.3%
 
20.905 1 0.3%
 

Serve_Size
Numeric

Distinct count146
Unique (%)42.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean324.48
Minimum9
Maximum907
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum9
5-th percentile87
Q1163.75
Median294
Q3453
95-th percentile623
Maximum907
Range898
Interquartile range289.25

Descriptive statistics

Standard deviation195.48
Coef of variation0.60245
Kurtosis0.30656
Mean324.48
MAD158.67
Skewness0.80766
Sum1.1032e+05
Variance38214
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 9. 110.5 199.5 201.5 337.5 ... 445. 456.5 609. 634.5 907. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
453 45 13.2%
 
340 38 11.2%
 
623 20 5.9%
 
566 16 4.7%
 
200 9 2.6%
 
595 7 2.1%
 
850 7 2.1%
 
161 5 1.5%
 
907 5 1.5%
 
249 5 1.5%
 
Other values (136) 183 53.8%
 

Minimum 5 values

ValueCountFrequency (%) 
9 1 0.3%
 
10 1 0.3%
 
14 1 0.3%
 
25 2 0.6%
 
29 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
907 5 1.5%
 
850 7 2.1%
 
646 1 0.3%
 
623 20 5.9%
 
595 7 2.1%
 

Ownership_Type
Categorical

Distinct count3
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
Company Owned
137
Licensed
121
Joint Venture
82
ValueCountFrequency (%) 
Company Owned 137 40.3%
 
Licensed 121 35.6%
 
Joint Venture 82 24.1%
 
Max length13
Mean length11.221
Min length8
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

Carbohydrates
Numeric

Distinct count92
Unique (%)27.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean43.771
Minimum0
Maximum141
Zeros (%)5.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q128
Median41
Q356
95-th percentile98.4
Maximum141
Range141
Interquartile range28

Descriptive statistics

Standard deviation26.936
Coef of variation0.6154
Kurtosis1.8172
Mean43.771
MAD19.724
Skewness0.9975
Sum14882
Variance725.57
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 19.5 65.5 81. 141. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 19 5.6%
 
30 11 3.2%
 
50 10 2.9%
 
34 9 2.6%
 
38 9 2.6%
 
41 9 2.6%
 
42 9 2.6%
 
49 8 2.4%
 
32 7 2.1%
 
56 7 2.1%
 
Other values (82) 242 71.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 19 5.6%
 
1 2 0.6%
 
2 3 0.9%
 
3 1 0.3%
 
4 2 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
141 1 0.3%
 
140 1 0.3%
 
139 1 0.3%
 
135 2 0.6%
 
118 1 0.3%
 

Longitude
Numeric

Distinct count260
Unique (%)76.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-56.761
Minimum-158.02
Maximum80.26
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-158.02
5-th percentile-149.14
Q1-99.325
Median-87.265
Q3-71.123
95-th percentile77.591
Maximum80.26
Range238.28
Interquartile range28.202

Descriptive statistics

Standard deviation76.967
Coef of variation-1.356
Kurtosis-0.63566
Mean-56.761
MAD63.87
Skewness1.0037
Sum-19299
Variance5924
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-158.02 -157.835 -149.435 -149.125 -123.295 ... 77.055 77.23 78.435 80.215 80.26 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
72.83 8 2.4%
 
72.82 4 1.2%
 
-112.02 4 1.2%
 
72.84 3 0.9%
 
-77.04 3 0.9%
 
-94.18 3 0.9%
 
-86.16 3 0.9%
 
-75.29 3 0.9%
 
-111.89 3 0.9%
 
72.86 3 0.9%
 
Other values (250) 303 89.1%
 

Minimum 5 values

ValueCountFrequency (%) 
-158.02 2 0.6%
 
-157.95 1 0.3%
 
-157.86 1 0.3%
 
-157.84 1 0.3%
 
-157.83 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
80.26 1 0.3%
 
80.25 2 0.6%
 
80.22 1 0.3%
 
80.21 1 0.3%
 
78.45 1 0.3%
 

Category
Categorical

Distinct count14
Unique (%)4.1%
Missing (%)0.0%
Missing (n)0
Hot Beverages
99
Breakfast
49
Cold Beverages
45
Other values (11)
147
ValueCountFrequency (%) 
Hot Beverages 99 29.1%
 
Breakfast 49 14.4%
 
Cold Beverages 45 13.2%
 
Smoothies & Shakes 34 10.0%
 
Chicken & Fish 26 7.6%
 
Desserts 24 7.1%
 
Snacks & Sides 17 5.0%
 
Beef & Pork 15 4.4%
 
Sandwiches and Wraps 10 2.9%
 
Salads 6 1.8%
 
Other values (4) 15 4.4%
 
Max length20
Mean length12.712
Min length6
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

Protein
Numeric

Distinct count42
Unique (%)12.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean11.694
Minimum0
Maximum87
Zeros (%)14.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median10
Q317
95-th percentile32.05
Maximum87
Range87
Interquartile range15

Descriptive statistics

Standard deviation10.991
Coef of variation0.93985
Kurtosis6.0817
Mean11.694
MAD8.3916
Skewness1.639
Sum3976
Variance120.8
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 16.5 27.5 42. 87. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50 14.7%
 
2 21 6.2%
 
1 19 5.6%
 
12 16 4.7%
 
9 16 4.7%
 
10 15 4.4%
 
11 14 4.1%
 
15 14 4.1%
 
4 13 3.8%
 
14 13 3.8%
 
Other values (32) 149 43.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50 14.7%
 
1 19 5.6%
 
2 21 6.2%
 
3 10 2.9%
 
4 13 3.8%
 

Maximum 5 values

ValueCountFrequency (%) 
87 1 0.3%
 
48 1 0.3%
 
44 1 0.3%
 
40 2 0.6%
 
39 1 0.3%
 

Country
Categorical

Distinct count2
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
US
258
IN
82
ValueCountFrequency (%) 
US 258 75.9%
 
IN 82 24.1%
 
Max length2
Mean length2
Min length2
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

Energy
Numeric

Distinct count151
Unique (%)44.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean337.8
Minimum0
Maximum1880
Zeros (%)5.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q1176.5
Median299.5
Q3460
95-th percentile740.5
Maximum1880
Range1880
Interquartile range283.5

Descriptive statistics

Standard deviation231.85
Coef of variation0.68636
Kurtosis5.7022
Mean337.8
MAD174.27
Skewness1.4793
Sum1.1485e+05
Variance53755
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 9.800e+01 3.395e+02 3.415e+02 4.280e+02 4.305e+02 5.550e+02 8.350e+02 1.880e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 18 5.3%
 
340 10 2.9%
 
430 10 2.9%
 
280 9 2.6%
 
250 8 2.4%
 
260 7 2.1%
 
330 7 2.1%
 
140 7 2.1%
 
290 6 1.8%
 
100 6 1.8%
 
Other values (141) 252 74.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 18 5.3%
 
1 1 0.3%
 
7 1 0.3%
 
8 1 0.3%
 
9 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
1880 1 0.3%
 
1150 1 0.3%
 
1090 1 0.3%
 
1050 1 0.3%
 
990 1 0.3%
 

Trans_Fat
Numeric

Distinct count10
Unique (%)2.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.18324
Minimum0
Maximum2.5
Zeros (%)67.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30.1
95-th percentile1
Maximum2.5
Range2.5
Interquartile range0.1

Descriptive statistics

Standard deviation0.38171
Coef of variation2.0832
Kurtosis6.4084
Mean0.18324
MAD0.2625
Skewness2.4728
Sum62.3
Variance0.14571
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.05 0.25 0.45 0.55 0.8 1.25 2.5 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 229 67.4%
 
0.1 32 9.4%
 
1 30 8.8%
 
0.5 18 5.3%
 
0.2 17 5.0%
 
1.5 8 2.4%
 
0.3 2 0.6%
 
0.6 2 0.6%
 
0.4 1 0.3%
 
2.5 1 0.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 229 67.4%
 
0.1 32 9.4%
 
0.2 17 5.0%
 
0.3 2 0.6%
 
0.4 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
2.5 1 0.3%
 
1.5 8 2.4%
 
1 30 8.8%
 
0.6 2 0.6%
 
0.5 18 5.3%
 

Cholestrol
Numeric

Distinct count59
Unique (%)17.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean47.544
Minimum0
Maximum575
Zeros (%)20.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q14
Median25
Q355
95-th percentile250
Maximum575
Range575
Interquartile range51

Descriptive statistics

Standard deviation81.815
Coef of variation1.7208
Kurtosis18.847
Mean47.544
MAD46.398
Skewness3.8984
Sum16165
Variance6693.8
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 4.500e+00 5.500e+00 3.450e+01 ... 9.250e+01 1.250e+02 2.310e+02 2.975e+02 5.750e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 70 20.6%
 
5 26 7.6%
 
35 20 5.9%
 
25 17 5.0%
 
30 14 4.1%
 
40 14 4.1%
 
50 14 4.1%
 
15 12 3.5%
 
10 11 3.2%
 
20 9 2.6%
 
Other values (49) 133 39.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 70 20.6%
 
1 4 1.2%
 
3 8 2.4%
 
4 4 1.2%
 
5 26 7.6%
 

Maximum 5 values

ValueCountFrequency (%) 
575 2 0.6%
 
555 2 0.6%
 
300 1 0.3%
 
295 1 0.3%
 
285 1 0.3%
 

Store_ID
Categorical, Unique

First 5 values
10052-99312
10084-99523
10168-99962
10170-96331
10211-99817
Last 5 values
9392-95294
9587-97243
9703-97484
9706-96992
9813-97844

First 5 values

ValueCountFrequency (%) 
10052-99312 1 0.3%
 
10084-99523 1 0.3%
 
10168-99962 1 0.3%
 
10170-96331 1 0.3%
 
10211-99817 1 0.3%
 

Last 5 values

ValueCountFrequency (%) 
9813-97844 1 0.3%
 
9706-96992 1 0.3%
 
9703-97484 1 0.3%
 
9587-97243 1 0.3%
 
9392-95294 1 0.3%
 

Total_Fat
Highly correlated

This variable is highly correlated with Energy and should be ignored for analysis

Correlation0.9065

Customers
Numeric

Distinct count338
Unique (%)99.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13071
Minimum1002
Maximum24964
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1002
5-th percentile2186.3
Q16877.2
Median13373
Q319244
95-th percentile23604
Maximum24964
Range23962
Interquartile range12367

Descriptive statistics

Standard deviation6993.9
Coef of variation0.53505
Kurtosis-1.2246
Mean13071
MAD6034.5
Skewness-0.076019
Sum4.4443e+06
Variance4.8915e+07
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1002. 24964.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
9932 2 0.6%
 
4331 2 0.6%
 
8888 1 0.3%
 
3760 1 0.3%
 
3365 1 0.3%
 
17075 1 0.3%
 
8884 1 0.3%
 
16053 1 0.3%
 
9925 1 0.3%
 
12471 1 0.3%
 
Other values (328) 328 96.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1002 1 0.3%
 
1119 1 0.3%
 
1128 1 0.3%
 
1156 1 0.3%
 
1223 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
24964 1 0.3%
 
24780 1 0.3%
 
24599 1 0.3%
 
24465 1 0.3%
 
24344 1 0.3%
 

Best_Selling_Item
Categorical, Unique

First 5 values
1% Low Fat Milk Jug
4 piece Chicken Nuggets
6 piece Chicken Nuggets
9 piece Chicken Nuggets
Apple Slices
Last 5 values
Veg McMuffm
Veg Pizza McPuff
Veg Supreme Muffin
Walnut Brownie with Hot Fudge - Medium
Walnut Brownie with Hot Fudge -Regular

First 5 values

ValueCountFrequency (%) 
1% Low Fat Milk Jug 1 0.3%
 
4 piece Chicken Nuggets 1 0.3%
 
6 piece Chicken Nuggets 1 0.3%
 
9 piece Chicken Nuggets 1 0.3%
 
Apple Slices 1 0.3%
 

Last 5 values

ValueCountFrequency (%) 
Walnut Brownie with Hot Fudge -Regular 1 0.3%
 
Walnut Brownie with Hot Fudge - Medium 1 0.3%
 
Veg Supreme Muffin 1 0.3%
 
Veg Pizza McPuff 1 0.3%
 
Veg McMuffm 1 0.3%
 

City
Categorical

Distinct count139
Unique (%)40.9%
Missing (%)0.0%
Missing (n)0
Mumbai
 
28
New Delhi
 
14
Bangalore
 
10
Other values (136)
288
ValueCountFrequency (%) 
Mumbai 28 8.2%
 
New Delhi 14 4.1%
 
Bangalore 10 2.9%
 
Pune 8 2.4%
 
Gurgaon 7 2.1%
 
Washington 7 2.1%
 
Cincinnati 6 1.8%
 
Cleveland 6 1.8%
 
Hyderabad 6 1.8%
 
Alameda 6 1.8%
 
Other values (129) 242 71.2%
 
Max length17
Mean length8.5294
Min length4
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

Gross_Profit_Margin
Numeric

Distinct count333
Unique (%)97.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.5233
Minimum-4.882
Maximum19.459
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum-4.882
5-th percentile-2.8736
Q10.0695
Median1.434
Q36.185
95-th percentile14.156
Maximum19.459
Range24.341
Interquartile range6.1155

Descriptive statistics

Standard deviation5.1931
Coef of variation1.4739
Kurtosis0.14985
Mean3.5233
MAD4.2126
Skewness0.91877
Sum1197.9
Variance26.969
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-4.882 -1.3665 0.361 0.912 0.95 7.763 14.231 19.459 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.776 2 0.6%
 
0.935 2 0.6%
 
-2.424 2 0.6%
 
0.134 2 0.6%
 
4.981 2 0.6%
 
1.434 2 0.6%
 
0.914 2 0.6%
 
-1.955 1 0.3%
 
14.268 1 0.3%
 
0.581 1 0.3%
 
Other values (323) 323 95.0%
 

Minimum 5 values

ValueCountFrequency (%) 
-4.882 1 0.3%
 
-4.789 1 0.3%
 
-4.582 1 0.3%
 
-4.535 1 0.3%
 
-4.512 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
19.459 1 0.3%
 
18.179 1 0.3%
 
17.639 1 0.3%
 
17.457 1 0.3%
 
17.056 1 0.3%
 

Saturated_Fat
Numeric

Distinct count64
Unique (%)18.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.5956
Minimum0
Maximum24.1
Zeros (%)24.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.5
Median4.55
Q39
95-th percentile15.05
Maximum24.1
Range24.1
Interquartile range8.5

Descriptive statistics

Standard deviation5.2194
Coef of variation0.93277
Kurtosis0.10323
Mean5.5956
MAD4.2604
Skewness0.85726
Sum1902.5
Variance27.242
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.25 0.95 4.95 5.1 ... 8.05 8.95 9.05 16.1 24.1 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 83 24.4%
 
8 18 5.3%
 
6 16 4.7%
 
10 16 4.7%
 
7 14 4.1%
 
3 14 4.1%
 
12 12 3.5%
 
4.5 11 3.2%
 
3.5 11 3.2%
 
5 11 3.2%
 
Other values (54) 134 39.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 83 24.4%
 
0.5 3 0.9%
 
0.9 1 0.3%
 
1 3 0.9%
 
1.1 5 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
24.1 1 0.3%
 
20 4 1.2%
 
19 2 0.6%
 
18 1 0.3%
 
17.9 1 0.3%
 

Dietary_Fibre
Numeric

Distinct count9
Unique (%)2.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.5441
Minimum0
Maximum9
Zeros (%)34.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q33
95-th percentile5
Maximum9
Range9
Interquartile range3

Descriptive statistics

Standard deviation1.6637
Coef of variation1.0775
Kurtosis1.7572
Mean1.5441
MAD1.3348
Skewness1.2929
Sum525
Variance2.768
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=9)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 3.5 5.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 117 34.4%
 
1 85 25.0%
 
2 52 15.3%
 
3 47 13.8%
 
4 18 5.3%
 
5 11 3.2%
 
7 5 1.5%
 
6 4 1.2%
 
9 1 0.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 117 34.4%
 
1 85 25.0%
 
2 52 15.3%
 
3 47 13.8%
 
4 18 5.3%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 0.3%
 
7 5 1.5%
 
6 4 1.2%
 
5 11 3.2%
 
4 18 5.3%
 

Revenue
Highly correlated

This variable is highly correlated with Number_of_Employees and should be ignored for analysis

Correlation0.90912

Sugars
Numeric

Distinct count88
Unique (%)25.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean26.347
Minimum0
Maximum128
Zeros (%)10.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q14
Median16
Q343.25
95-th percentile77.1
Maximum128
Range128
Interquartile range39.25

Descriptive statistics

Standard deviation26.896
Coef of variation1.0208
Kurtosis1.082
Mean26.347
MAD22.071
Skewness1.1916
Sum8958
Variance723.41
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 18.5 71.5 128. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 36 10.6%
 
2 23 6.8%
 
3 19 5.6%
 
7 12 3.5%
 
6 11 3.2%
 
15 8 2.4%
 
5 8 2.4%
 
59 7 2.1%
 
45 7 2.1%
 
12 7 2.1%
 
Other values (78) 202 59.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 36 10.6%
 
1 5 1.5%
 
2 23 6.8%
 
3 19 5.6%
 
4 7 2.1%
 

Maximum 5 values

ValueCountFrequency (%) 
128 1 0.3%
 
123 1 0.3%
 
120 1 0.3%
 
115 1 0.3%
 
103 1 0.3%
 

Number_of_Employees
Highly correlated

This variable is highly correlated with Cost_Price and should be ignored for analysis

Correlation0.90912

Selling_Price
Numeric

Distinct count335
Unique (%)98.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean14.603
Minimum0.851
Maximum40.275
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.851
5-th percentile2.026
Q16.9135
Median13.712
Q320.425
95-th percentile32.432
Maximum40.275
Range39.424
Interquartile range13.512

Descriptive statistics

Standard deviation9.4677
Coef of variation0.64832
Kurtosis-0.52726
Mean14.603
MAD7.6581
Skewness0.45109
Sum4965.1
Variance89.637
Memory size15.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.851 2.8695 3.3235 3.3945 6.676 10.287 19.8815 35.2135 40.275 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3.391 2 0.6%
 
3.38 2 0.6%
 
3.394 2 0.6%
 
3.348 2 0.6%
 
3.384 2 0.6%
 
3.025 1 0.3%
 
3.35 1 0.3%
 
12.296 1 0.3%
 
34.146 1 0.3%
 
21.737 1 0.3%
 
Other values (325) 325 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0.851 1 0.3%
 
0.896 1 0.3%
 
0.926 1 0.3%
 
1.085 1 0.3%
 
1.426 1 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
40.275 1 0.3%
 
38.749 1 0.3%
 
37.466 1 0.3%
 
37.256 1 0.3%
 
36.071 1 0.3%
 

Correlations

Missing values

Sample

Last rows

Best_Selling_ItemCarbohydratesCategoryCholestrolCityCost_PriceCountryCustomersDietary_FibreEnergyGross_Profit_MarginLatitudeLongitudeNumber_of_EmployeesOwnership_TypeProfitsProteinRevenueSaturated_FatSelling_PriceServe_SizeSodiumStateStore_IDStore_NameSugarsTotal_FatTrans_Fat
330Shamrock Shake (Medium)109Smoothies & Shakes75Billerica8.703US405406607.13642.58-71.2965Company Owned1.6611420.30712.015.839453210MA8650-20641Billerica9319.01.0
331Shamrock Shake (Large)135Smoothies & Shakes90Boston6.759US1835408200.37442.35-71.1352Company Owned3.6401815.77115.07.133623260MA22253-2188261304 Commonwealth Ave.11523.01.0
332McFlurry with M&M’s Candies (Small)96Smoothies & Shakes50Boston14.616US1442316503.88142.35-71.08104Company Owned6.4741334.10514.018.498310180MA7544-27387755 Boylston St8923.00.5
333McFlurry with M&M’s Candies (Medium)139Smoothies & Shakes75Boston16.894US203432930-0.86242.34-71.10119Company Owned9.9142039.41920.016.032460260MA11726-105182Fenway Triangle Trilogy12833.01.0
334McFlurry with M&M’s Candies (Snack)64Smoothies & Shakes35Fort Mohave9.236US1109714304.09535.02-114.6068Licensed3.344921.55110.013.331207120AZ25967-242726Smiths Fort Mohave #4735915.00.0
335McFlurry with Oreo Cookies (Small)80Smoothies & Shakes45Fort Mohave7.022US461015105.55035.02-114.6053Licensed1.4351216.3859.012.572285280AZ74975-101172Safeway - Fort Mohave #14746417.00.5
336McFlurry with Oreo Cookies (Medium)106Smoothies & Shakes55Fountain Hills14.714US208001690-1.11033.61-111.73105Company Owned8.7981534.33212.013.604381380AZ5586-1312E. Palisades & Ave of the Fountain8523.01.0
337McFlurry with Oreo Cookies (Snack)53Smoothies & Shakes30Fountain Hills9.518US238921340-2.29233.61-111.7370Licensed6.406822.2086.07.226190190AZ74539-65039Safeway - Fountain Hills #12914311.00.0
338McFlurry with Reese's Peanut Butter Cups (Medium)114Smoothies & Shakes60Fountain Hills20.891US10091281010.38733.57-111.72146Licensed7.0532148.74515.031.278403400AZ20344-204610Target Fountain Hills T-143210332.01.0
339McFlurry with Reese's Peanut Butter Cups (Snack)57Smoothies & Shakes30Gilbert8.669US969614104.49433.28-111.7964Licensed2.8441020.2298.013.163202200AZ76302-96624Super Target Gilbert ST-19605116.00.0

First rows

Best_Selling_ItemCarbohydratesCategoryCholestrolCityCost_PriceCountryCustomersDietary_FibreEnergyGross_Profit_MarginLatitudeLongitudeNumber_of_EmployeesOwnership_TypeProfitsProteinRevenueSaturated_FatSelling_PriceServe_SizeSodiumStateStore_IDStore_NameSugarsTotal_FatTrans_Fat
0Egg & Cheese Muffin28Breakfast244Hyderabad0.907IN397922900.74817.4278.4534Joint Venture0.172142.1177.01.655112620AP23149-228271Banjara Hills213.00.2
1Sausage McMuffm28Breakfast50Hyderabad0.454IN115622730.44217.4878.3925Joint Venture0.055161.0595.70.896112950AP23191-228548Kukatpally211.00.2
2Sausage & Egg McMuffm29Breakfast277Hyderabad1.931IN1034623550.93417.4378.3954Joint Venture0.664224.5057.92.8641571020AP23193-228546Madhapur217.00.2
3Veg McMuffm38Breakfast21Hyderabad1.460IN741432990.93517.4278.4245Joint Venture0.398103.4067.22.3941191000AP23180-228545Jubilee Hills312.00.2
4Veg Supreme Muffin39Breakfast11Hyderabad3.143IN1788742990.25217.4578.3877Joint Venture1.65777.3335.23.395139960AP24457-238129Hi-Tech City413.00.2
5Hot Cakes with Maple Syrup64Breakfast16Hyderabad1.337IN665223720.91117.4578.3842Joint Venture0.34063.1206.42.248142630AP23664-232349Mindspace210.00.4
6Hash Brown16Breakfast1Delhi2.227IN1218721660.85728.6777.1359Joint Venture0.86525.1954.83.08464370DL20874-208485Punjabi Bagh210.00.1
7McEgg Burger32Breakfast227Delhi3.314IN1895022810.07828.5777.1281Joint Venture1.832127.7323.83.391115700DL29491-254065T3 Domestic Arrivals212.00.1
8Chicken Maharaja Mac52Sandwiches and Wraps64Gurgaon0.906IN397055450.74728.4677.0734Joint Venture0.171262.1148.91.6532461030DL22446-221249HUDA Metro Station726.00.2
9McChicken49Sandwiches and Wraps31New Delhi1.995IN1074434310.92228.5777.1755Joint Venture0.705154.6546.02.917173840DL23392-229965R K Puram520.00.2